From what I've seen the look of water is usually not provided by the engine itself. Water is really hard to make look good and a lot of it depends on the specific needs of a game.