If there can be dancing swords, why not be able to put that kind of magic to use with self firing wands. I see no real difference. The dancing swords have enough insight and control to be able to attack foes in a coordinated way, why not the wands. I would likely limit the wand types to basically offensive spells though, so as to keep in line with the same types of magic used to animate a weapon.
A better variety of weapon might be a rechargeable staff with the dancing effect on it. Makes more sense IMO and seems better suited to long-term usage (and can physically attack as well).
A specific spell to animate wands could be an easy way to allow this. I would imagine the spell as the same level as Animate Object... just different, and limited only to wands. Possibly another specific spell to animate a rod, or other variants as well.