I can’t help, Anne, with a varietal recommendation. It sounds as though your soil needs organic matter to hold more moisture. Light soils are easy to ‘work’ and to access but not so good for moisture loving veg such as climbing beans and celeriac. Even regular watering can be of limited value in hot weather, so beans may do better as autumn takes over.
Can you find some good compost or manure to spread?