Revellers are warned they may end up with a night at the "Lock'em Inn", which currently has vacancies.
A police spokesman said it was a light hearted way of getting the message across that getting drunk can have serious consequences.
The Inn is described as "minimalist chic" with sturdy locks on all rooms.
Acting sergeant Neil Whyman said: "These leaflets have a serious message. We see too many people who don't know when to stop on a night out. They drink too much and get involved in alcohol-related crime and disorder. The aim is to encourage people not to drink to excess.
"The Lock'em Inn is one place you don't want to stay and the leaflet will hopefully get the message across."
The leaflet has comments from real-life "guests" including: "It was the worst night of my life," and "I feel ashamed - my kids don't understand why I wasn't there in the morning."
Olwen Kelly, community safety and substance misuse manager for Safer South Gloucestershire, which funded the leaflet, said: "The Lock'em Inn project will hopefully get people thinking of the personal consequences, should they be involved in anti-social or criminal behaviour due to excessive drinking.
"We want people to enjoy themselves, but to do so in a safe, sensible and social manner."