The ghost of Madam Piggott who died in childbirth 200 years ago has been seen walking from the church to her nearby home, a large Elizabethan mansion.