For the years we traveled to the mainland, we always relied on the 5 gallon bottles, called garafons. This water is called purified water - to what extent it is, may always be a mystery. But personally, we were never sick traveling in Mexico. In a boondocking, beach situation, for two people, we would use three or four garafons per day. One would be set out in the sun near the shower tent, warmed by the sun until after we did our snorkle around the coral for about an hour, and by then the shower water (pumped by the spare 12 volt water pump) would be wonderful, one-half the bottle each.
We would do all our cooking outside, where another garafon provided this kitchen with water, also used during the early morning, for brewing coffee. A third bottle resided inside our motor home. These last two would be equiped with an inexpensive Mexican made hand pump, available in many stores for about 3 or 4 dollars. Quite often a truck will deliver to an area with several RV's present. Buying these will give you reliable drinking water and it certainly is not unheard of to fill your rig's water tank with this source, or likely a better idea, fill it partially, as you wouldn't want the water to sit in the tank for too long.
But all the time we traveled, we'd "try" to keep the water tank as sanitary as possible, but in reality we never use the tank for drinking purposes. Brushing teeth, washing up, and even showers yes, but never for drinking, making coffee, or cleaning fruits and vegetables. Many make it a hobby to treat the water that enters their water tank although we never did and these days, wintering mostly in south western USA, we still do the same, carrying one garafon,filling it from machines near grocery stores, and a 15 gallon plastic tank that we use to carry water with our towed car from other, even cheaper sources, back to the rig (using the same pump for the transfer into the big tank).