A new code to clamp down on "irresponsible" drinks promotions in Northern Ireland is set to go live tomorrow (1 September).