Water flow through pipe animation

 From:  Shaun (MOISHAUN)
4628.6 
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.