It's okay to use VPS over water. Just don't fly close to the surface of the water with it enabled. Also, you should refrain from pulling the left stick (throttle) to the full down position over water since it might engage Forced Landing mode. If that happens, you can cancel the landing.
Because the signal is awesome as there are no line-of-sight issues with your aircraft.