Flying over water in a single is only a few percentage points more risky than an equivalent trip over land. Mountains, forests or night-flying are more dangerous in the event of a forced landing than a ditching on water.
It's an individual decision but, properly prepared and equipped, you can expand the utility of your aircraft.
This article gives a good perspective of the risks involved.