Aberdeen city council co-leader to step down as Tories dominate list seats and Alba miss out