A former mayor and vice-chairman of the Social Democrats has resigned from his party post to become a lobbyist, following a significant defeat for the party in municipal elections.