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.
This plugin is available for download to be used on your WordPress self-hosted installation.