To cancel your Pub Site account, log into your site, find the "Website" tab in the menu, then click "Account":
On the Account page, scroll down to Cancel your Pub Site Account. Check the box and click on Cancel Now: