Maya fluids would be the best. Or you could just take an emmitter, set the bong to be a collision object, then just download vladmirjp's water texture. A tutorial for the collision object is at digital tutors .com your going to have to register.
Imagination is more important than knowledge.