A Sheffield awards scheme which champions a safe night-time economy has scooped a prestigious national award.