With loose powder, just a dull "whoosh", not loud, some flame or smoke and like Corey said a very dirty barrel.

With pellets, make sure you do it at night. It'll shoot little flaming pellets up into the air.