Lighting apparatus and installations, in particular for events, decoration, advertising and for living areas, in particular LED lamps and luminaires