Implement `has_dtor` method in TypeContents

The patch also adds a `type_has_dtor` function to keep consistency with
the other functions present in this module.
Don't allow static items with `Drop`

Partially addresses #10577