A new public park on the northside of Dublin combines wind power and sustainable water management with environmentally sound materials and strategies to boost biodiversity, making it a standard-bearer in urban design. Lenny Antonelli visited the site