Adding my two cents in as somebody who gave up alcohol about 6 months ago, I had a lot of the same worries. Alcohol used to tame my social anxiety (although it was often actually the excuse to drink that got me going out). I used to become really gregarious after drinking, and I was afraid about how I would handle social situations without a drink in my hand. I didn't want to completely shelter myself from drinking events or force my friends to have to abstain from drinking around me, because this wasn't about them.
Since then, I've attended and hosted parties, gone to music festivals, hung out with friends, gone to bars, etc. Although there have been awkward moments (being the only sober one at a party after a few hours when everybody's drunk gets boring), it's been amazing! I've found my sober confidence, and honestly except for some curious questions ("you're still not drinking?"), nobody's cared. I'm just as much fun and social, actually more. I don't start slurring my speech and saying dumb things after getting wasted. I can let go easier, especially once others are a little tipsy, because I have more of my faculties than they do. I can drive to places I couldn't have if I'd been drinking. The key is always having a non-alcoholic beer or other drink in my hand so I don't feel awkward or left out.
If I want to let loose a bit more, I might smoke a bit of pot.
Overall, I don't really feel like I'm missing out on much anymore, which has been shocking. I realized that for me, more than the alcohol itself, it was the ritual of the cold drink (which NA beer scratches) and bring able to get out of my own head that was i.portant.
Hope this helps!