What's the purpose of the lighting?

Better not to use lighting unless you use downlights that are dark skies compliant or yellow bulbs. The world is over lighting everywhere to the detiment of insects and birds

The primary purpose of the lighting is for dining and entertaining in the evening.

Would you not want overhead lights instead of lighting the fence? There are lots of diy methods of hanging string lights overhead without a structure. Usually it involves posts standing in tall planters with the lights strung from the posts.