I have a MeFOTO RoadTrip tripod, and I like it. Full size, yet collapses down impressively small, more than anything I've seen. It's made for traveling, but is still study enough for anything I'd ever need it for. And can convert to a monopod. My only complaint is I don't much like ball heads
If you plan on using it for now than this, you could look into that. But it's probably more then you'd want to spend if this is the only thing you need it for. Probably can should find something cheap (but well rated) on Amazon.
Other tips:
Use a light pollution map (
https://www.lightpollutionmap.info/) and drive to a dark area. As far away from the cities as you can.
The widest, fastest lens you have.
Long exposures, of course
Get a remote shutter release if you can. Use timer mode if you can't. Either way, don't touch that stuff