I once drank a bottle of lake water straight from the lake, way out in the wilderness in northern Ontario. No negative effects. I don't remember the water tasting particularly good or bad.
Ugh. Don't do that. The water is disgusting in Ontario. There are some pretty strong guidelines regarding eating fish from there too. Heard stories from people who need to test it and filter it for injectables. It's not out in the wilderness, but it's still a good idea to just avoid it. So you drank one bottle that's different from sustained consumption.