Scottish Tory councillor and council leader who called Nicola Sturgeon a 'drooling hag' defects to Labour