Heavy Neutral Leptons from low-scale seesaws at the DUNE Near Detector