The RNLI has announced it will provide a new state-of-the-art lifeboat next spring to a Co Cork station.