Green leak detective could be prosecuted after watchdog accuses him of 'flagrant violation' of the public's trust in police