Give particles a go. I think if you google water in maya you should find some tuts, I think that Mike McKinley had a tutorial on his stie if I remember rightly.