Former depute SNP group leader will stand for Alba in upcoming by-election, nearly three years after he left the council.