A new 113-mile trail linking Moffat to Berwick-upon-Tweed is set to boost tourism in the Scottish Borders, with Scottish ministers confident it will attract visitors from across the UK and beyond.