Sandwell has won a national public health award for its Covid vaccination programme.