Local government workers have voted to accept a revised offer from council employers after strike action earlier in the autumn, Unison has said.