You could live like royalty in this north-east castle for just £475,000