No, the police would not put someone who is sleeping on the street due to excessive drinking into custody. Generally they will offer the person assistance to provide them with a safe place to stay and access to medical help. In some cases, the police may issue a warning and/or citation for public intoxication.