Scottish Water illegally discharged sewage hundreds of times during dry weather, soiling beauty spots such as West Sands beach at St Andrews.