The mayor of Swindon officially resigned from his post after his remarks about disabled people sparked a controversy