Scottish Rugby Union chairman David Mackay has resigned after a vote of no confidence by the general committee.