Council apology over Lyra lights failure