You can cancel your Hootsuite account or downgrade to a free one from within the Hootsuite Dashboard.
Go to My profile, and then select Account settings, preferences, and billing.
Scroll to the bottom of the page, and select Account Removal.