My youngest daughter and her husband are big hookah fans. She worked in a hookah bar for a couple of years. It has a great following around here.
When I was a teen I built my own hookah from repurposed science hardware from school. We had a lot of fun gathered around that hookah. We were smoking store bought pipe tobacco. They have a million different smokes now flavored with this or that. It was fun back in the day and quite the vehicle to be social. A real novelty in the sixties. I started smoking a pipe when I was in grade school so it was right up my alley.
There is no cleaner smoke than pulling it through water... or whatever. It removes a great deal of the tars leaving the flavor.
If you invest in your own hookah, or hubble bubble as we called it, be warned that the liquid becomes very nasty in a short time.