I once drank lake water in Iceland during winter. The only reason I could be convinced to do so was because it was Iceland during the winter. It was absolutely fantastic. Easily the best tasting water I've had by an order of magnitude.
Source: drink frequently from springs in/around towns.