'My house is ruined' - Locals describe 'soul destroying' flooding in Cork