Good Option North of Santa Fe
Dirt road leading up to campground was totally drivable but heavily washboarded at the beginning, so be advised if you're towing. Plenty of room for my 25ft travel trailer and larger rigs should be okay as well.
No water, power, or dump station, but there are individual garbage containers at each site. As others have said, you can get water at the North Lake campground, but there's a pass you'll need to buy to get in. I think it was $20 bucks for a year, and gets you access to a few other recreation areas further north.
Seems like a lot of people come to the campground for day use just to hang and look out at the lake. If you're staying long term, I'd avoid the overlook sites as there will be noise and traffic right there.
I stayed at one of the sites around the back which looks out at the mountains - not a bad view.
$9 per day when I was there.