I was once chummy with motel owners, who were dismayed when a group of louts smoked pot with a hookah, leaving a vile stench behind. They consulted other owners, who told them that most of the stink is clinging to fabrics, and to clean all the fabrics in the room.
If the smell persists on the walls, you can buy treated cleaning sponges. They remove dirt without entailing messy water, buckets, etc.