Video: North-east’s newest SNP councillor ‘thrilled and delighted’ after close win