Fianna Fáil emerges as largest party of local government as European election sees high-profile exits