Its not uncommon for people to travel between ceremony and reception. My friend was going to get marries 30minutes away from her reception venue and we had to go home in between. It rained tho so was all in town in the end.
maybe your DF should consider compromising if its too costly/difficult to find a reception venue nearby if you don't want people to travel too much. I wanted to get married at a park by the river, my DH on the beach, so we got married at a vineyard overlooking the beach, with beautiful grounds. Was just more practical for us too.
also, even tho you don't drink wine, don't assume others won't if offered it. We had a limited tab for beer and wine, all spirit's were cash only, wedding party drank for free.
your venue will need to fit your intended guests if they all came, but keep in mind a 100% attendance is unlikely. We invited 140 people and had 110 attend. If you find a perfect venue but its a lower guest capacity, don't be afraid to reduce how many people you invite. We had no +1s where we didn't know they had a partner or we hadn't met them.
keep looking, you have a while to find somewhere perfect smile