It's pretty much as you said.. diffuse and alpha.. create a watery diffuse texture and alpha mask it. Then add some mist with a particle sprayer. I don't really know much about the particle part, but there should prolly be some info about it on google
Cheers!