Add destroy_with_password method

Similar to `update_with_password`, I created the `destroy_with_password` method. I'm currently using this myself as a method in the user object, but thought it'd be cool if it was part of devise. Unsure if this is something that should be in the core of devise though.