You can still stay home, and you don't need to make excuses for it - just that you want to stay home this new year's eve. As to seeing your friend before they leave the country, can you meet them somewhere other than the bar?
Just keep reminding yourself of your goal of sobriety, and don't pick up that first drink!