The head of the Greek intelligence service has stepped down during a scandal after spying on journalists and an opposition politician with their mobile phones targeted by spying software.