Return error when no ScriptPubKeyMan is available for specified type

Summary:
When a CWallet doesn't have a ScriptPubKeyMan for the requested type
in GetNewDestination, give a meaningful error. Also handle this in
Qt which did not do anything with errors.

Backport of Core PR16528 [39/43] : https://github.com/bitcoin/bitcoin/pull/16528/commits/3c19fdd2a2fd5394fcfa75b2ba84ab2277cbdabf

Test Plan:

ninja all check-all

Reviewers: #bitcoin_abc, jasonbcox

Reviewed By: #bitcoin_abc, jasonbcox

Differential Revision: https://reviews.bitcoinabc.org/D8467