Ports like Cozumel have restaurants and resorts that specifically use purified water (even to make their ice) so no worries.
We have eaten in Nassau, Freeport and dozens of other ports without an issue.
As long as you stick with a tourist place....you should be fine.
Now I would not recommend drinking from a public water fountain.... but then I don't do that here in the US either....