CONGRATS! I know how you feel. We had my BIL engagement party when we found out with our first.
I went with the 'I have been really run down with a virus so on antiobiotics'. This worked perfectly for those who noticed I wasnt drinking. Otherwise I had lemonade in a champagne glass and no one knew the wiser!
Have a great time away, Margs is lovely, my dad lives there