You could get a terrain tile what will be placed ONLY under water.
Then just make a trigger:
Every 1 second
Pick every unit in playable map area matching condition and do actions:
-(Terrain type at position of matching unit is equal to (your special terrain type)
Actions:
Set picked unit mana to mana of picked unit - 10 or whatever you'd like the value to be,
Hope i helped.