The Sinn Féin vote has collapsed in parts of the country in the local elections with councillors set to lose seats nationwide.