Plans to create Scotland's third national park in Galloway and Ayrshire have been scrapped, the Scottish government has announced.