Hugo Burge spent his final decade turning Borders mansion house and estate into culture quarter