Plans by Lidl to replace its existing outlet in Fermoy with a large, new store have been approved, despite opposition from a rival supermarket owner.