Fruit Hookahs are great because not only do they look amazing, they also taste amazing.
Of course, what would be a zen hookah session with Buddha's approval?
Golden Cobra hookah - not to be confused with the Limp Bizkit album.
Tired of ice? Maybe build a refrigerator around your hookah!
On the other hand, if your hookah is too cold (for some reason?), you can make a lava lamp hookah! Although it's probably not recommended to filter your smoke with lava.
This is a pretty awesome, Steampunk-inspired hookah
If you're satisfied by the little things in life, perhaps these micro-hookahs will tickle your fancy.
Or, you can be like Fantasia and build a gigantic hookah with a massive Mya base.
Not to be outdone by the 2012 Olympics, of course (I'm certain this is a real hookah)