Regional leader Carlos Mazon says he has done everything he can in the face of a ‘monstrous avalanche of water that exceeded all weather forecasts’