Yes, both of your adopted children in Skyrim can get pets, but it depends on your home and interactions. Each child can adopt one pet, so if you have two children, you can have two pets in total. Pets include dogs, foxes, mudcrabs (with Creation Club content), and even skeevers. The child may randomly bring home a stray or ask to keep an animal they find.