Water is available only at the trading post, it is $2 a bottle. Not sure if Ocean view has a frig, our tropical waterfront did. Our frig didn't work well, cool not cold, even on 100%.
As far as drinking the water, everyone said that it was safe to drink. I did good for the first 6 days, I had a rough ride home and 2 days later I still have a hint of the problem. I am very sensitive to this so maybe the average person wouldn't have an issue. It did taste fine though. My wife who normally has an iron clad stomach had a slight hint of discomfort the day after we returned home.
All of the drinks have ice, it's hard to avoid. Maybe it was the Carib beer, blahh, and I didn't drink a lot of it.