Cuckoo Cottage in Northumberland offers walks to a waterfall, ancient settlements and picturesque villages from its doorstep and has been described as a 'magical' getaway