I've worked in both.
Small village:-
Pros - family feel, everyone knows everyone, older support younger etc. Depending on the school, they may even do whole school trips.
Cons - smaller friendship pools, lack of resources, maybe mixed age group classes
Large school:-
Pros - more diverse so better opportunities for learning first hand about different cultures, languages and beliefs, much more scope for different friendships, a bigger mix of people prepares them better for secondary school/'the real world', generally better resourced, more clubs and sports teams etc, children more likely to be taught in same age group.
Cons - can seem more 'intimidating' to young children as far more children and staff to het to know and busier playground, less chances of staff knowing all pupils in the school (although some will make an effort to), classes may be mixed each year (personally I see this as a pro, as it means opportunities for new friendships and mixing with different people, but many parents on here seem to see this as a con if their child is separated from their best friend).
All children are different and will thrive in different environments. Personally I would advise visiting both during the school day to get a true feel for them.
One mistake you don't want to make is assuming small school will mean they will get 'more support' as smaller classes. They'll likely be in mixed year groups if the intake is small so still the same amount of children in a class, but with much less budget as less pupils on roll so poorer resources.