A historic walled garden and glasshouses in the Borders are to open to the public for the first time in more than 40 years.