A probe is under way after more than 100 containers containing hazardous waste were found dumped near a river in Cork.