A culvert trash screen which became blocked with debris during a torrential downpour, triggering a devastating flood through a Cork suburb, is to be removed.