Hoya will probably work and not need a lot of water. Possibly a Rhipsalis. You could use a self-watering pot that has a large reservoir so you don't have to get up there so often, but "a couple times a year" is nowhere near frequent enough. Maybe once a month at best.