Re: Big hookah!
I hate that thing... Lol.
It's called the Sultan or the Harem most commonly. It is a somewhat functional pipe but it has a LOT of problems. The part of the base with the glass is not part of the actual hookah. it's just an attached stand. The area above that is the actual vase. The vase is solid metal and is a pain to fill properly. From the reviews I have seen it's not great quality and the draw is not so good. I don't know from personal experience.
It's an interesting piece but as you said, Blaat, it is mostly for show.