The new public realm at Northbank at Wirral Waters will include four new contemporary squares