So long as they have a secure cage that is out of reach of the dogs and not in an area that the dogs reside or play in you will be fine.
Yes, a dog actively attempting to open the caging will stress out the snake. That is why you should not house the snakes in a room the dogs will primarily be in. I have mine in a completely seperate part of the house that the dogs rarely enter so they show no interest in the snakes.
If you house them in the same location and the dogs begin to show interest int he cage(s) then you add unnecessary stress to the snake. Simple to avoid.
As far as the type of dog it doesn't really matter. The point is to avoid entering the snake cages as a point of interest.
Funny yet appropriate story... last night I was taking the puppy back in from going potty and walked by the GTP cage and she nearly struck the front of the cage showing interest in my puppy so yes, snakes show interest in dogs and can get stressed if they are in close contact even through a cage.