My little boy is almost a year old.
The sleep deprivation in the early weeks was unreal. I think it helps to understand that newborns don't have day and night, they just have an endless nap cycle, i.e. wake, nappy change, eat, sleep on a 2-3 hour cycle. It does get much better after a while, and once they are sleeping for 4 hour stretches you will feel much better, even if you are still waking up a couple of times in the night to feed.
You will be very constrained by nap times. When your baby is a newborn and napping all the time but anywhere, take the opportunity to go out with your baby in the pram, carrier or car. Newborns are very portable. The worst stage is once they get to around 3-4 months old and still need lots of naps but need to have them at home. Then you only get very short windows of time to go out. It gets much better once they drop to two naps, and even easier when they drop to one.
If you plan to breastfeed, it's very hard at first (nobody warned me how sore my nipples would be) but if you make it through the early weeks it gets much much easier and for me it is one of the best things I have ever done. If you do plan to breastfeed, however, get a Haakaa to express milk and give your baby a bottle a couple of times a week from when they are about a month old. Trust me, you don't want a bottle refuser.
The smiles and giggles and cuddles are amazing. ❤
Try to enjoy the newborn snuggles because they're not quite the same once your baby is heavy and wriggling and wanting to look at everything.
If you have parents or in laws close by who are willing to babysit and you trust them, get into the habit of leaving the baby with them every now and again. The first time I did it, my baby was 6 weeks old and I went for a pedicure. Your life will be much easier if you are able to leave the baby with someone else even if it's just for an hour or two. And once you feel up to it and your baby (and boobs, if applicable) goes a full evening without a feed, or can take a bottle, go out for dinner with your friends. Having a baby absolutely does not have to be the end of your social life.
It'll be fine. You've got this.