The two situations aren't really connected are they ?
Many of the people you refer to have mental issues. We should be doing more to help them. The drunks is a law enforcement issue. Both those issues could be better served by being given higher priorities by governments.
The community should demand this ? Why are people in your community tolerating this behviour ?
