Nearly 50 sites run by Scottish Water including sewage and wastewater treatment are “poor”, “very poor” or “at risk”, according to Scotland’s environmental watchdog.