Super Mario Bros 3! I think the whole of world 3 or 4 has a water setting and they did a lot of creative things with it.
