WordPress can allow your user to register by themself, but has no function to delete their own account.
You can also create Resign Page which displays message to your customer.
Are you sure to delete your account? We miss you.
Este plugin está disponível para download para ser usado em sua instalação auto-hospedada do WordPress.