Per-material Water

On per-material base water can be selected from Material->Animated Water Effect option.

By using Opacity option water can be combined with original material.