BUG/DEPR: deprecate Categorical take default behaviour + fix Series[categorical].take
closes #20664

I might be unavailable for the next few hours, so I'm just putting this up here, even though it includes changes from https://github.com/pandas-dev/pandas/pull/20814 in the first commit. Once that is merged, this can be merged on top of master and it'll just have the categorical changes.