A formal planning application has been submitted for a new 40-lodge luxury holiday park in the Borders which would create up to 18 new jobs.