Sewage watchdog pledges to work with local councils in bid to hold Southern Water to account