Sinn Féin has been thrown into even more turmoil in the Cork East constituency following the resignation of one of its county councillors.