Never-before-seen diaries shed new light on amazing life of American heiress turned crucial protector of Scotland’s musical heritage