A half-witted person, a “Bess of Bedlam” (q.v.).
“[None] can say Foster's wronged him of a penny, or gave short measure to a child or a cousin Betsy.” —Mrs. Gaskell.
Source: Dictionary of Phrase and Fable, E. Cobham Brewer, 1894
More on Cousin Betsy from Infoplease: