I'm going to cancel my party so my friend won't show up.
Why do you want your friend to miss the party?
He drinks too much and causes an embarrassing scene.
You shouldn't cancel your party because of one person. Talk to your friend about their behavior.
I only want friends that don't drink too much to come to my party.
You should talk to your friend about their drinking. It might be helpful to just let them know that there will not be any drinks served at the party. There is no need to cancel such an important event.