I don't know much about your problem but you can go for FLUENT and COMSOL. These do quite a lot of jobs. My labmates use them albeit these are commercial and costly.
I also suggest the OpenFOAM software. I'm familiar with it more than two years and found it as the most powerful CFD software. Now let us know, what do u intend to model?
Check out the CSDMS website. They host the names, source code, and a lot of information about various software packages that are open to the public. It is a great resource.
The answers I've seen are suitable for single phase solve problems. If you want to solve a problem two phase water-air then CFX is a very good choice (FLUENT is included in this package).
If you have to solve a problem of sediment transport, then FLOW-3D is a good choice.
It depends somewhat on your problem. For free surface problems I would recommend Flow 3D. If the shape of the free surface is not a problem (either pressure flow or you can assume it fixed) go with fluent or CFX. For free I would recommend OpenFoam, but it requires some programming skills to use.
There are a lot of software which based on special issue you can use:
Flow 3D: provides a powerful tool for complex fluid modeling problems. FLOW-3D enables highly accurate simulations of free-surface flows using TruVOF, the original and true form of the Volume-of-Fluid technique.
Fluent: includes well-validated physical modeling capabilities to deliver fast, accurate results across the widest range of CFD and multi-physics applications
Delft 3D: 3D modeling suite to investigate hydrodynamics, sediment transport and morphology and water quality for fluvial, estuarine and coastal environments.
HECRAS: one-dimensional steady flow, one and two-dimensional unsteady flow calculations, sediment transport/mobile bed computations, and water temperature/water quality modeling.
Mike11: Rivers and reservoirs, Forecasting, Hydrology, Sediments, Water quality
OpeanFoam: has an extensive range of features to solve anything from complex fluid flows involving chemical reactions, turbulence and heat transfer, to acoustics, solid mechanics and electromagnetics.
Comsol: software solutions for multiphysics modeling.