I think the only real answer is RO and UV filtration.

RO won't remove everything, but UV will kill everything.

I'm not Chief O'Brien but I use a reverse-osmosis water filter installed under the sink, that has its own drinking water tap. It has 6 or 7 stages of filters and a pressurized tank to hold a few gallons of filtered water. And it does remove bacteria, chlorine, fluoride, lead, and pretty much everything but water. I installed it about 10 years ago and it was a fantastic investment. It cost under $200 if I recall, and the yearly cost for filters is about $50 to $100 to have unlimited pure water. Filters must be replaced every 6-12 months, except for some like the RO membrane that lasts 2-3 years.

I used to live outside of Dallas and they had an algae bloom during the summer in whatever reservoir that would make the ice maker reek of garlic for a few months a year in the summer.