Development of superconducting nanowire single photon detector technologies for advanced applications