The executive (mayor) shall appoint subordinate officers and employees with the advice and consent of council under procedures established in section 3122 (relating to appointment of subordinate officers and employees), except that, in counties, the office of prothonotary and clerk of courts, register of wills and clerk of orphans court shall be filled by appointment by the president judge of the appropriate court with advice and consent of a majority of the council.