What mood does hookah get you in?

If you're smoking tobacco out of it, then no, it won't get you buzzed. Maybe lightheaded or nausous.