According to the Irish Water website, it is advisable to engage with them regarding connectivity of a new premises early in the planning permission stage.
The following web page describes the Pre-Connection Enquiry and the Confirmation of Feasibility. According to this, the process takes around 16 weeks (3.7 months)
https://www.water.ie/connections/pre-connections/