They sell hookah in some night markets, and cost about 1000~2000 baht. I dont know the currency exchange. However its pretty crappy. I would recommend going to a hookah bar instead. Also i think you can ask the ppl at the hookah bar if they sell hookah there but im not sure.