Not a simple topic, and much misinformation of limited information. I just submitted a series of 4 articles to Practical Sailor.
1. You really need to filter the water you load at the hose end. Though the municipal is safe, I bet there are substantial amounts of algae and bacteria living in the hose. While these are not pathenogenic, they put sludge in your tank and give bugs plenty to eat. You can't sanitize a tank, even with bleach, if there is ANY measurable sludge in it. Just like dishes, they must be washed before sanitizing. Keep the sludge out.
Put a filter on the inlet while you're at it. Bugs are flying in. It's in the plumbing code (16 mesh), but most boat makers skip them. Go figure.
2. If you are going to leave the boat for more than a week, treat with a chemical that gives a longer lasting chlorine residual than bleach. There are tabs, using a different chemistry (EPA and WHO recognized) that lasted for months instead of days in our testing. Huge difference.
3. Filter before the tap, and not just some granulated carbon filter; with non-chlorinated water, they grow far more bacteria than they remove. Get something NSF 53 rated. As a side benefit, any carbon filter will remove all of the chlorine.
4. And at the end of the season, winterize with the right concentration (weak glycol or vodka ferments something awful) or sanitize the system with tabs, and then drain and dry the tank. You wouldn't put the dishes away dirty and wet, would you?
---
With a good system design, there is simply no reason not to drink tank water, and no reason that it cannot be as fresh, safe, and pure as bottled water. It's just about getting the chemistry right. Carrying more than spare water in bottles is wasteful of effort, resources, space, weight, and money. No upside.