I have a basic beach splash system going.
You can see the splash in action here: http://www.youtube.com/watch?v=EbpXD3VZDy0 from 1:30 - 1:45
I just catch the overlap event and spawn the splashes and sound at the actor location, with Z set to water height (0 in my case).
