We've made 3 trips, with 6-10 people each time. Drink the bottled in the villa, brush with the tap, make coffee from the tap. Had water at the eating spots, and ice in the drinks. Eaten everything everywhere. Never a hint of any upsets that could be tied to food or water (other drinks, maybe, but not because of the ice).
On our different trips to the Yucatan, we did avoid water, even unsealed bottled water (some hotels would refill them from the tap) and stayed away from salads and a few other things. Never an issue on AC, eat, drink and be merry.

Been there, done that, the washing machine ate the T-shirt