A newly-introduced life-saving nasal spray has been used for the first time on a woman suffering a potentially lethal opioid overdose in Sheffield city centre.