The president of the church, who is also the president of the council, is appointed by revelation, Doctrine & Covenants 102:9

Trivia: Who will reimburse Joseph Smith if he has to pay back the money that Ezra Thayre gave to the church?