The walnut (Juglans regia) is the better choice if you want fruit.
The tree itself is quite frost-resistant and robust. For fruiting, frost is an issue, though, as the flowers are sensitive. But it naturally blooms in mid-to-late spring and there are cultivars that bloom especially late to be one the safer side. Your nursery should be able to help you. Except first fruit when the tree is ten to twelve years old.
Before planting, remember that walnuts grow into large trees quickly and they can be tricky to prune: Cut at the wrong time and the tree will bleed profusely and for a long time. Ideally you plant it in a free space where it can grow largely untouched. Also note that a walnut emits chemicals into the soil that suppress other plants, so that the area under the tree will be rather inhospitable. In my experience, grass will grow, but don’t expect a flowerbed to thrive. A walnut tree is not the tree of choice for a small front garden, but given enough space, they grow into majestic trees, and faster than many others.
Almonds (Prunus dulcis) are true lovers of warmth and sun. They are typical plants that need Mediterranean climate or at least the conditions found in vineyards. As they leaf out rather early and blossom even before, they are rather sensitive to late frosts (cold winters aren’t that much of an issue), which will of course affect fruit formation.
Note that most almonds available in garden centres and nurseries are breed for their impressive flowers and may not bear fruit at all. Talk to your nursery, if you want to give a fruiting tree a try. You should get the first fruit as early as the third to fifth year, if you are lucky and get no frost.
And of course with only a third of the size of a walnut and the somewhat dainty growth, plus the profusion of flowers in spring, it’s much more suitable for the smaller decorative garden - but not for a larger-scale almond production in Northern England.