Huntingdonshire District Council have blocked plans to re-open a former pub as a convenience store in St Neots.