Ancalagon
Dusty Dragon
I'd probably have it take an action to use for a single shot (no extra attacks with other weapons), do 8d6 in a 120' line (like lightning bolt, but all bludgeoning/piercing), and take 2 actions to reload it. Also explodes on a natural 1 (8d6 piercing damage in 20' radius centered on the user).
Magical ammo could create a stinking cloud at the end of the line (or centered on the first creature hit in the line), or could explode with each creature it hits, causing smaller AOE's as it passes through, or could "bounce" allowing you to send it around corners.
I think that damage would be very reasonable for a small cannon as in a small *artillery piece*, but why such a high damage for a non-magical hand held weapon? If it was that potent the recoil would wreck the user. I'm not saying you are wrong, but I would like to hear your logic.