Congrats! We are just about 6 months in.
The baby will get used to the noises it hears in the womb now, as others have said you shouldn't have to tip toe around a sleeping baby. We have several barking dogs and they don't phase her too much.
Every baby is different, no matter what advice you get you will have to tailor it to your experience and your child.
We went with cloth diapers instead of paper, and have had a very positive experience. If it's something you're open to I can go into more detail.
Be supportive of your wife, don't expect much sleep for the first few months. I had an idea of what we were going to be dealing with and we managed it pretty well. No matter what there are going to be a few nights where you are just exhausted and aggravated, but you endure. Don't shake the baby! The memory of the first few months is fading now that she sleeps through the night, I still don't know how we did it but I do remember that as we were going through it it didn't feel that bad.
We breastfeed so that is my experience, and it has worked out well. Puts some more burden on the working mom but good for baby. Check with your hospital, they may have a lactation consultant who can really help you get started and who you can check in with when you have any problems.
We have lots of family in the area, her mother came in from out of town and stayed with us for the first week, which was nice, but you also need to be ready to tell people they can't come over or to give you a break if they are dropping by too much.
Don't be afraid to take a healthy baby places, ours was out to the store and family events in the first few weeks, and slept in her car seat at a restaurant while we had lunch at three weeks old.
Enjoy yourself.