Hey MagicRat, first of all congrats. There's a LOT that will change, and much that won't. There's good and bad, but the good far outweighs the bad IMO.
First, you get the baby home, put him/her on the bed, and basically say, "Ok, now what do we do?". That's the funny part.
Things that will change right away will be that someone will have to get up to feed the baby every 2-3 hours for at least a month, or maybe more. If your wife is nursing, it will be her so make sure to be nice to her, especially when she looks extra tired. If it's formula, be ready to share in the duties (and to rejoice when, at 6 months or so, the baby takes the bottle and holds it themself at 3 o'clock in the morning). After a month or month and a half, you'll lie awake wondering if the baby is ok when they've slept for 5 hours. This is a good thing, expecially after you see them sleeping away and go have a celebration with the spouse about getting more sleep soon.
A healthy baby will cry when hungry, wet, cold, hot, uncomfortable, or lonely. After a bit you'll be able to tell the difference, and if you're tuned in to the wee one you'll hear the first couple of sounds that signal it's time for the bottle to be ready, or the diaper needs to go.
Speaking of diapers, I've heard of plenty of people that gagged the first couple; but after awhile it's no big deal, and gets automatic. Baby wakes up? Diaper. Going to sleep? Check diaper. Feeding? Diaper. Smell? You get the picture. You'll probably have some funny poo stories that you and your wife can share.
Easy transition to carrying around baby supplies, get a backpack or something for it all, and restock when you get home. Get used to leaving about 10-15 mins after you planned, as putting together baby supplies can take awhile (especially in winter).
Unless you've got a babysitter, plan on not getting hammered at the same time as your wife, and also leaving places you've gone to early; while the baby's little you might want to head home to match naptime and such. As he/she gets older it won't matter as much.
Porta-crib =
Unfolds from a 6"x6"x3' package into about a 3'x4' crib. Perfect for when you're not home, although I used mine for naps at home also.
I've blathered on quite a bit, hope this is the kind of stuff you were after. Most of all, enjoy seeing the world through a new set of eyes, and teaching the little critter
everything.