Scotland’s First Minister has said pay talks for council workers are “closed” as he condemned the “utterly unacceptable” targeting of his constituency by a trade union.