I am staying sober for my own health and well being, I don't care what anyone thinks of me for it. Those same people who might call you, or think of you as, a party pooper, will they be at your hospital bedside to keep you company as you're dying from liver failure? I'll bet not.
If you really want to stop drinking for your own good, then stop drinking for your own good. Who cares what anyone else thinks or says? True friends will encourage you in getting healthier, drinking buddies will not. I'll stick with my true friends, how about you?