From Halopedia, the Halo wiki
Hookah tobacco is a San'Shyuum stimulant that is smoked via water pipe. Although the drug allows San'Shyuum extra focus and mental acuity for a short duration, later reactions to the drug can include an extreme headache. A quick-acting herbal tea is available to deal with the side-effects, produced by clerics.
List of appearances