I always drink from streams higher up, in the dales anyway, and seem to survive okay.

A word of warning though - I was recently turned inside out for a week by a bout of gastroentiritis and I almsot certainly got that from swimming in Coniston Water in heavy rain, following a week of dry weather. In those conditions apparently its common for tummy bugs to be picked up.