One of Scotland's most iconic wedding destinations is to undergo an £8 million revamp as it transforms itself into a "true destination".