The Spider Control Rod is less a weapon than a remote control. It fires a beam of energy, and Aicantar’s Dwarven spider walks toward wherever the beam lands. The rod looks almost the same as the Aetherial Staff, just with a different gem colour and a less golden shaft. Its whole purpose is one quest, and it does that job well.
Where to find it
During the Thieves Guild quest Hard Answers, you can steal it from Calcelmo‘s Laboratory in the Dwemer Museum inside Understone Keep in Markarth. Go up the stairs, take the first room on the left, and it is on a table. If you have the Creation Club content Forgotten Seasons, there is another one in Runoff Caverns at the Summer’s Chords, entered from Vardnknd Gallery. It sits on a shelf at the first right turn, near the lever that deploys a repair spider.
Is it worth using?
Inside the quest, absolutely. You use the rod to guide Aicantar‘s spider down a hallway filled with poison gas, so it can do the dangerous part while you stay healthy. That is clever, slightly ridiculous and very Dwemer. Outside that one moment, the rod has no real function. The spider cannot be interacted with in any other way, and it does not seem able to leave the laboratory area, so you cannot take it adventuring. The rod deals a token amount of damage, and staffs use their own charge rather than Magicka, but nobody in their right mind is fighting dragons with it.
If you like the idea of a Dwemer automaton that follows your directions in combat, look at the Aetherial Staff from Dawnguard instead. It summons a Dwarven Spider or Sphere for 60 seconds and actually fights for you. The Spider Control Rod is best kept as a trophy from a fun heist, or put on a display rack next to other Dwemer oddities.
Good to know
The sources do not say which magic school the rod uses, so the school field is left empty on purpose.
Stats from the Skyrim game files; locations checked against community wiki articles, written in our own words.

