The bowl that I got is very stealthy. I can cup the entire thing and slide it into my pocket easily if need be. I think it was about $25 at this headshop in town, can't remember the exact price.

Really, just go with a cheap pipe. We don't all smoke out of the same shit around here lol. Just look at the pictures and find one that fits your needs.

Also, a bubbler will cool your smoke, but bubblers and bongs aren't stealthy at all. If you want to smoke discreetly you basically have to tolerate the heated smoke, or start cooking with your weed. Eating weed brownies in public is a thing of joy