A council’s adult social care delivery has made a “significant improvement” in its Care Quality Commission (CQC) rating.