A Public Spaces Protection Order to curb "irresponsible" alcohol consumption takes effect from July.