Social care leaders have warned that the Budget will cause "catastrophic unintended consequences" for hospitals in North Wales.