Future of Scotland's first minister hangs in the balance as Greens back no-confidence motion