The council leader said he has taken the decision following ‘a recent change in my personal circumstances’