HARPS-N unveils a new super-Earth in the habitable zone of a nearby red dwarf