Thousands of tonnes of raw sewage contaminated a beauty spot killing fish, including rare species.