Around 1,200 permanent jobs could be created at the holiday village in the Scottish Borders.