The SNP-run local authority voted to back a three percent visitor levy on overnight stays in hotels and other accommodation.