Lots of stuff to do, not sure how much is of interest to a 9-year old. Multiple forts, houses that have tours, museums, nice walking town. Fairly nice shopping street.
I have stayed at the Hampton Inn in the historic district. Can be a good option if you have Hilton points.