North-east left battered by Storm Ciara