Work which will enable both NHS community hospital and residential care to be delivered from Rothbury Community Hospital is now complete.