I don't drink ANY "wild" water locally except in one particular area (Kisatchie Hills Wilderness Area) after it's been raining, and I'm sure it's mostly rain water. That I'll treat with iodine (Polar Pure). For the rest of my trips in/around Louisiana, I carry it all in a 5 gallon container. If I do the Neches someday (about 40 miles west, in TX) I might treat it, but as long as I have the canoe, I prefer to draw it from the tap. There is just too much ag runoff here in this part of the country (bottom of the Mississippi watershed), the local loggers think nothing of spilling a 5-gallon bucket of hydraulic oil on the ground and kicking dirt over it to avoid cleaning it up, and lord only knows what else has been dumped over the years at Fort Polk (2 major streams originate there).
In the Smokies and Adirondacks, I just treat it all with iodine for drinking, or boil it as part of a meal (I'm lazy... dehydrated meals are about all I do.) Boiling is a major pain... my biggest pot is about 2 qts/1.9l, and I go through a bit more than that in a day. Water is also heavy, so I don't like to carry more than 2 qts, especially when backpacking. I usually have one brewing and one to drink from.
I don't filter... tried it backpacking for a couple years, but the filter alone is a pound... Tried Aqua Mira drops, but the mixing is inconvenient. Iodine is a bit faster, stupid-simple, and takes no longer
how to boil water when camping. So once I tried Polar Pure, I never looked back. You can't get it anymore, but they still sell the jar (with the insert to keep the crystals from falling out). You can buy the crystals ("prilled iodine") through eBay or a company in Canada called RAEMS.