Councillor wants a by-law reinstated to ban drinking in public in the popular Welsh resort