I dont think for a simple scene like this that you would need to use fluids or dynamics, some simple poly objects to representthe water will do.

Unless of course you want to animate, and if you do I would reccomend using realflow for water simulations. (theres a free 15 day trial for it on nextlimits site)