So there's not really anything balanced in the exact way you want it, but there are options:ĭovah Defense - Yakudan Shehai and Dwarven Thu'um Cannons, also includes Nordic Spellguns, which is probably a more lore-friendly approach to what you want
The only way to do a pistol in Skyrim is to have it be a staff.