Looks like Blender is a good choice, I will take a look at the animation tutorial.
Do you think Modo is another water flow animation software that I can consider ?
It really depends on how complicated your animation needs to be. You may not need physics simulations at all depending on what you're doing. In that case an easy to use and affordable program like Carrara might do the trick.
