“A man was beheaded there and sometimes you can hear his head rolling down”: The historic Loch Ness manor once home to Jimmy Page and Aleister Crowley is opening to the public for the first time in 260 years