I have looked at a map and it's just as I suspected. It's an island which by definition is surrounded by water on all sides. Seems to me one could watch a sunset over the water from any island.
Long Island is an island and you do not see the sunset setting over the water. You see it setting over Manhattan which is an Island. In fact if you watch the sunset in Manhattan (an Island) you see the sunset over New Jersey. To see the sun set over the water you need about 12 miles of open water in the direction of the sun which sets approximately to the west but only twice a year really to the west.