SNP makes gain from Labour in council by-election as Reform vote grows