Legendary Scots castle to be sold after makeover