Why is water not rendering
There are two distinct problems with your water not being renderable, one for the viewport preview other for the final render.


Viewport - In the viewport the water simulation is invisible because it's Maximum Draw Type is set to Wire - Under the Properties Window > Object Tab > Display Panel change the Maximum Draw Type from Wire to Solid or Textured
Final Render Your domain is set to non renderable in the outliner - Go to the outliner and set it renderable by clicking the camera icon