Looking at this diagram, I dont think this would work.
Typical hookah setups (hookah is around 1ATM or 33 feet) put out around 50psi and 2 to 4cfm per diver. If you are working hard, you will need more than 2CFM.
Looking at this, at 50 psi you get a little less than 2 cfm, and it never gets to 4, and then you have to consider what depth you want to max at.
hookah max is 2.55 at 65psi, while this one is about 1.75 at 65psi
It needs to be an oil free compressor, not necessarily a medical grade compressor.
A very common air compressor to use for hookah is the Thomas 1020. (2.62 CFM at 50PSI)
SuperSnorkel
View attachment 1457269View attachment 1457270View attachment 1457273