Not sure I can help with the water textures; I think there are some out there for FS9. This picture is from FS2002, and the replacement water textures came from a payware addon for photoreal south-east England scenery. One of the extras was coastal water replacement textures, which show up wherever there's a coast, which is a bonus. The shade varies with the water depth (by the look of it.)
