A police officer was forced to resign after being caught having séx during an undercover drug operation, according to police reports in Arizon