Water options for a game ready title

[Bhoutei]

How would you approach a hybrid water system? Do you know any good tutorials out there?
thanks