New George Street councillor says his win ‘shows Aberdeen South by-election hammering was nothing to do with SNP’