I did a recent post on some nice water for the game engine, but some people were asking for ripples and splash fx, so I found a really nice method for using splash fx in game engine using the apricot splash texture.
Here is the .blend file http://www.mediafire.com/download.php?2twilnf4vs5
Latest apricot build req.