The latest Lightwave newsletter mentions a plugin that allows the import of Blender fluids. Blender's simulator is very cool, and Blender is completely free, of course. Once in Lightwave, you can texture using Lightwave's awesome surfacing system and render engine. I haven't tried it yet, but it looks great.
You can find the plugin and tutorial here.