A Sinn Féin councillor has been suspended from his position after being convicted of being drunk in charge of a vehicle with excess alcohol.