This patch includes the improved procedural water that was tested in the 3.3.5a client.
Please note that whilst this water is improved, it does not look like Cataclysm water. This was made possible due to the fact that Blizzard were experimenting with improved water in 3.3.5a. In outdoor zones, it generally looks better than the old water.