I said I was going to do it and here it is. After some hours tinkering in the workshop with my son, this is what I ended up with. I decided to use a firecracker instead of powder and BB's for projectiles because that's what I had readily available. Didn't spend anything but time.
Here's...