Scared of getting a dog?

I've basically been told by my husband we're getting a dog. Puppy is coming home at the end of august. I don't feel prepared mentally. I'm worried about the dynamic changing with my cats, I'm worried about the mess and the noise and all the possible "what if" situations. But I'm really scared I'll just have resentment towards both my Mr and puppy because I did not want this...