The diseases that a healthy unvaccinated puppy can spread to vaccinated adults are not likely to be serious.
There are a few exceptions (ringworm and flea infestation come to mind), but it is very unlikely that your cats will come to serious harm when the new puppy is introduced.