Edit: Maya 2011 now supports this out of the box. Go nab it.
So after a days worth of research I now have the information needed to emit fluid from particles in Maya. A whole new world of possibilities has been opened!
First off grab this file - though I only know it works FOR SURE in [...]

Here’s what I sold my soul (and summer) to.