A unified super local authority in Cork would be a “disaster” for the region and would spell the end of local government in the county, one of Ireland’s longest serving local politicians warned.