A hookah, حقّہ (Nastaleeq), also known as the qalyân (Persian: قلیان), is a single- or multi-stemmed instrument for vaporizing and smoking flavored cannabis, tobacco (often Mu‘assel), or sometimes opium, whose vapor or smoke is passed through a water basin—often glass-based—before inhalation. The word hookah is a derivative of "huqqa", a Hindustani term.
Many of our leading Ulama say that it is not permissible to smoke cigarette because it is damagingly harmful to the health of the person and people near him. Hookah is more dangerous to health than cigarette.
as salam alaikum
some scholars have forbidden smoking tobacco, others have allowed it. Certainly it is not a healthy habit and it is better to focus on other things that are not detrimental for our health. Allah gave most of us a voice that should be improved to recite the Qur'an beautifully and invoke Him, and sound health that is amanah and should be preserved to serve Him at the best of our ability.
As far as coming back home at late hours in the night, it is not a good habit also, and it is haram if it causes losing salat al-Fajr.
With prayers for your success.