Black powder might work for this.
Any smokeless pistol powder would need a lot of wadding to burn fast enough to give you a "bang". You'd basically have a cardboard projectile.
I believe commercial blanks use a very fast flash powder that's not available at your local reloading supply store.
Proud member of the NRA and Texas State Rifle Association. Registered and active voter.