I have been using the Apprentice HD version of Houdini for some time now and its a great piece of software. I am planning to use it as a fluid and smoke simulator with blender as the main modeling tool. Lets see how it goes.
The software is a great tool for special effect. A learning edition of the software can be downloaded from the following website and going to the download tab.