The Staff of Fireballs is the go-to area damage staff. It copies the Destruction spell Fireball: a ball of fire that explodes on impact for 40 points of damage in a 15 foot radius, with extra damage against burning targets. It suits warriors and archers who want an answer to crowds, and mages who want to save Magicka.
Where to find it
Mages and other spellcasters can drop it once you reach the right level. With Dawnguard, some Falmer carry a variant with a different look. Fixed copies: from the dragon priest Krosis at Shearpoint, from Vokun in High Gate Ruins, at Tolvald’s Crossing next to where the astral vision appears, and at Pincushion Peter, against a tree beside a knapsack. With Dragonborn, you can also craft one at Neloth‘s Staff Enchanter from three
Heart Stones and an Unenchanted Destruction Staff.
Is it worth using?
Yes, at least through the middle of the game. Forty points of splash damage clears weak groups fast. The staff runs on its own charge instead of Magicka, and soul gems recharge it. According to the source, a higher Destruction skill cuts the charge per use. Mind the blast radius in tight spaces, because your follower is standing in it too.
Stats from the Skyrim game files; locations checked against community wiki articles, written in our own words.

