I went to this shop and they had a hookah made of a Smirnoff Ice bottle for $25.

Seemed pretty easy to make, had a heavy rubber base.. I'm sure they sell a kit to make a beer bottle hookah somewhere, as you don't have to drill any holes or anything.