Agree that Chimney Rock is good. The lighthouse is spectacular though. The walk to it is also short (depending on parking) - two caveats: not always open and at the lighthouse there are perhaps 300 steps (children may need to be carried).
I have seen kids in the chimney Rock trail. It is quite flat and about a mile one way.
Thanks! Your answer is awaiting moderation.