A county councillor is campaigning to have a new greenfield emergency hospital developed on the northside of Cork.