In the past I've used
Numenor's WallWindows glass set. One of the recolors was of transparent glass with tall ornate fencing, not unlike some of the gated driveways I've seen. While it won't open and close as you'd like, I'm not sure that's possible. That seems like something that would have been created by now if it could be done.
You will need to use the cheat
moveobjects on to place the fence or driveway depending on what order you build it in.
Chaavik, the car would be able to leave, but a sim would need an actual gate to leave by. Included in Numenor's set are invisible doors, so if someone wanted to, they could put up an invisible wall on the lot frontage, stick in a door or two, yet keep trespasses and pets out.