Discovery of a super-Earth near to the habitable zone of a cool star