Add override to overridden destructors

[tamaskenez]

Add the optional override specifier to the ExplicitProducer and ImplicitProducer destructors. Silences the -Wsuggest-destructor-override clang warning.