The Lord Mayor's second in command has been announced