There can be a pretty wide selection of options for antennae and an even wider selection of parts for them, so maybe you can narrow it down to a couple of types to figure out what you'd need.
It sounds like your application is usually smaller antennae, so SMA is a good route as a primary connector (and RP-SMA is very common for antennas, so have at least a pair of adapters), but these cheap ones don't necessarily have great tolerances, so I'd get a good quality port saver (SMA male to SMA female) to protect the ports on your VNA from any connectors with issues/wear. If you're trying your hand at PCB antennas, I'm a fan of using semirigid or rigid coax as the interface and soldering it directly to the board - so some semirigid SMA cables cut in half are a reasonable, cheap starting point. If you want to be connectorized, then some RA and top entry SMA connectors would be a good choice (usually female, since cables are usually male to male). If you want to be constructing parts from wire, you want some reasonable gauge solid core wire with appropriate material/coating to prevent oxidation. You probably don't need substantial hardware or pipes for aerials just because at nearly 1 GHz, the size may be a bit small to use the construction style used for VHF or HF bands.