Galway City Council has given the green light to controversial plans for a new Lidl supermarket and off-licence in Knocknacarra.