The Staff of Ice Spikes copies the Destruction spell Ice Spike. Each spike hits for 25 points of frost damage to Health and Stamina, and frost also slows targets down. Draining Stamina means fewer sprints and fewer power attacks from the enemy, which is great news for anyone fighting up close.
Where to find it
It is rare loot across Skyrim, more common at higher levels, and certain merchants sell it occasionally. With Dawnguard, some Falmer wield a version with a different look, and one can be found in the Inner Sanctum. There is also a fixed copy near Winterhold, lying beside a dead mage inside a small stone circle surrounded by explosive runes. Walk carefully. With Dragonborn, you can craft it at Neloth‘s staff enchanter in Tel Mithryn from two
Heart Stones and an Unenchanted Destruction Staff.
Is it worth using?
At low levels it is strong, and the source agrees that it loses ground later on as better weapons and spells arrive. It uses its own charge, not your Magicka, and soul gems recharge it. According to the source, both a higher Destruction skill and Fortify Destruction enchantments reduce the charge each use costs. If you play a melee character, it is an excellent opener to tire an enemy before you close in.
Stats from the Skyrim game files; locations checked against community wiki articles, written in our own words.

