Cheapy ones are OK, had a sheldon black that hit bomb but too expensive. I'd invest in a nice bng if space no issue, otherwise get some double chamber or with some defuser or something, they do make a difference.
What, you've never smoked out of a bubbler before? What do you mean 'any input?'? Um, yeah, water filtration is great, make sure you ask them to put water in it before you buy it, so you can try inhaling through it and seeing if it gets water in your mouth. Pick something you like.