Millions of litres of raw sewage were pumped into one of England’s most famous lakes after a fault.