Failure at Stormont to agree a multi-year budget will make a major transformation of the health service harder to deliver, a senior official has said.