A redevelopment of the Fox and Hounds site, in the northside Cork City suburb of Ballyvolane, has been approved by Cork County Council.