When we got our pup, we already had two cats, they got on really well, they loved the dog and would lay with him. Initially there was a bit of a settling in period, he was the sort of dog that was happy for the cats to be the boss. We also got another kitten when he was about 4, the first meeting was quite something, dog was very excited, tiny kitten hissing etc! They shared a brilliant bond.
Our pup did a fair bit of destruction, chewed the spindles on the stairs, shoes if he got a chance, he was quite difficult to house train, he would happily wee outside, but not poo, often he would hold on, and poo when he got home. He was a collie. We had him for nearly 13 years. He was such a character, very loving. We have never got another dog, it is such a big commitment, pleased we had him though.
we didn’t have a crate, they weren’t a thing when we got him, he liked to sleep in our bedroom with us, which he did, until the babies came along, we moved him out and changed our bed. He accepts the babies as they arrived no problems whatsoever. He was quite a healthy dog, other than being prone to ear infections, main cause for veterinary visits.
Good luck OP, just accept there will be ups and downs, and honestly some days you will think whatever have I done, but you will get through it and have a lovely loyal dog for many years.