I've seen him more effectively used with a Fire Main, reason being, Fire's control. With Water, his defenses aren't enough to hold out against really strong offensive pressure. In addition, the clones he produces are fairly weak and they don't attack, further reducing his utility. The objective of the clones is to raise chakra, something that is more useful for Fire Mains than Water mains anyway.