Islam mentions every intoxicant as haram. But I do not feel intoxicated by smoking shisha because the water in the base tends to absorb tobacco.
So is smoking shisha/pipe haram?
Intoxicant eh? Do you get any good effects by Sheesha/Smoking? You don't!
Shisha has tobacco too, so its effects are the same! Anything that includes nicotine has a lot of bad effects on our body and would prevent many organs from doing there own general function. For example: Nicotine has a minor effect on blood pressure and heart beat rate, similar to caffeine and other weak stimulants.
Anything that is toxic to the human body is counted as intoxicant. Now you might have wondered why Pigs are not allowed to be eaten in Islam. That is because of a large number of parasites in its body. It is not because of its bad living environment. You can learn more here: https://en.wikipedia.org/wiki/Pig#Health_issues
Similarly, Islam stops us from using anything that is bad for our health. If you're a smoker, you would never say its a bad thing. Yet you will praise it for being an extraordinary helpful for tension patients. But, it has a large number of side effects and the number of good effects is none!
So everything that is bad, is haram in Islam! I would count this too.