Millions of litres of raw sewage was pumped into one of the UK's most famous lakes after a fault.