Being over water may confuse the altitude detection at a few metres, but above that it makes no difference to the drone's operation. Probably a quarter of my flights have been over the sea. The risk is the same as anywhere else you couldn't recover it from.