Ujean welcome!!!
This is my opinion: I know it's hard to say no, i've been in the same position with my partner. However, it is enabling, it's making it easy for him to go there, drink irresponsibly to the point that he's not able to make his way home by driving himself. An adult is responsible for his own behavour. If your husband goes there, gets drunk and then drives back home and causes an accident with possible devastating consequences for himself and/or others, you're not responsible, HE IS.
If he decides to stay there overnight because he decides that it is not safe to drive, it's HIS CHOICE. Nothing you can do about that, except SAYING to him that you're not happy that he sleeps out.
Love Jo