South Ayrshire Council has voted to support the creation of a new national park.