I'm not sure I'd want to shade an outdoor living space with hops, they can attract bugs that are messy. Here's an
old thread on using hops for shade.
On the other hand, I have seen grapes growing on second story arbors over an entire street in a small Greek village, just like you'd described your ideal planting. No growth at all at street level, really narrow street. Not sure how you'd harvest them there, or if anyone ever did. The pruning would be a PITA too. But with access from the second story, it could work.