Looks like mushrooms aren't Mario's only vice any more. Here's a Piranha Plant that actually will spew hot smoke, though in this case it's presumed that the user will want to be "hit" by it. Mario's used to disappearing into pipes, so it's only fitting to have a means for his consciousness to do the same thing.
He's going to need to hit a lot of bricks with his head to obtain this thing, though - it's made of glass, and running just under $85 on etsy. Thankfully, its potential "medicinal" delivery should cure the pain of scoring all those gold coins.
Although: "This item is intended for use with legal tobacco products only." Yeah. And Mario's just a plumber.