As a former public librarian and current person who walks their dog, I'm of two minds.
I've seen less drug use and public sex at local public libraries than at interstate rest areas and on hiking trails.
If you're going to overdose, I'd rather you do it in public where you can get help. If you're going to engage in public sex please don't do it around people that aren't into that. There are private clubs for that.