High-quality upgrades are attracting locals keen to trade up as well as people ‘on their way back’ to Cork — and people currently renting while waiting for the right house to come along