Does a castrated dog experience sexual desire?

So we're leaving our female dog with another family with a male dog. Our dog hasn't been sterilized yet, but the male dog has. I was just wondering whether the male dog will still have sexual desires and might attempt sex with our dog? Or are dogs without the ability to reproduce not interested in sex at all, since they can't reproduce?