The Scottish Government has ditched plans for a new centralised National Care Service.