I have 2 snakes, 2 cats, 2 dogs, 2 Leopard Geckos, 2 children and 10 Daycare kids.
My cats don't even pay any mind to the snakes when they are in their tanks. One of the cats scared of the snakes when they are out and the other looks from a distance with mild interest and then walks away.
As for my dogs, one is blind so that ensures no trouble there and the other one is very playful so he is the only pet here that is a possible threat to the snakes. When we bring the snakes out he goes in his kennel, simple as that.