Social care in North Wales could collapse due to a £40 million 'ruinous' Budget, experts have warned.