I'm not really planning something like this:
Just change the cup out for a hookah and you have an alcoholic hookah.
The dry will NOT be in the hookah vase, not even touching it.
Best way I can put it. bLook at this picture:
In the *** with the chocolate, that would be the bowl with the hookah vase in it.
The bigger *** is where the dry ice would be. Along with some water. The water and the dry ice would create a nice smoke effect, and freeze the *** which the hookah is in.