Keep in mind that the pressure shown in Fluent/CFX does not have the hydrostatic component (meaning the depth of the water is not included in the pressure). If you want to visualize this, it would be best to create a CCF (if working in Fluent) to see how the depth of the water contributes to the pressure. Similar questions have been asked many times on here, so do a search of the forum.