Limerick Hospital today opens its doors on one of the largest partnership projects in the history of the Irish health service.