Designed for five sons, the six-bedroom property combines durable finishes, expansive living spaces and panoramic views across Cork Harbour