From what I know of Chessies (see quite a few at shows and talk to the owners, as I adore them) they are stunning dogs, but not recommended 'beginner' dogs. That doesn't mean people without dog experience can't own them, but that they won't be as easy to train as say, a Golden Retriever, which, tbh, are born half trained.
Any working breed will be fairly driven and require a largeish amount of exercise, which once adult ahould be around 2 hours plus a day and include off lead exercise. As puppies they require much less exercise, but need occupying so they don't get bored and become a nuisance.
The best advice I have ever been given about dogs (by my mentor when we got our first dog from her) was that you get back what you put in. With any breed, if you're prepared to put in an immense amount of work, and seek professional help/attend classes if you need to, you'll end up with a well trained, well behaved dog. The amount of effort required with a Chessie is likely to be more than some other breeds though.
Chessies are also prone to Von Willebrands disease, a blood clotting disorder, I am not sure what current health testing schemes are available for this. They should be hip scored (probably elbow scored too ideally) and eye tested for PRA.
If you decide you are interested in them, speak to breeders now and they should be honest about whether the breed will suit you. You will also probably have to go on a waiting list now, as they aren't a very prolific breeds and I suspect waiting lists get full easily.
Personally, I think there are other breeds that would maybe suit your situation better. Any breed, if properly socialsed and not taken advantage of, will be good with children.