I mostly smoke my own hookah with friends.. But there is a place in San Diego we go a lot (we drive almost 2 hours to get there). It's called Tangier's. The owner is really cool and he makes his on flavors. They are all VERY good, best I've ever had. It's also really cheap to buy a lot. Good stuff.

http://www.tangierstobacco.com/