“Silent” fireworks will have to be used at all events held on property owned by Antrim and Newtownabbey Borough Council.