A suspect device which sparked a security alert in Derry was a viable pipe bomb, police have said.