The Scottish government is scrapping its plans to create a National Care Service.