North-east hotel overlooking Cruden Bay placed on market – and could be yours for £450,000