I've been on a yard bigger than that, about 90 horses. I actually liked being there as I found that I only got to know the people in the same stable block than me so it was actually irrelevant of how many people in total as it was almost too big to get to know everyone, so it was like being on a yard of 25 not 90. And also everyone mostly went up at different times, so never massively busy, but meant there was always someone there on the yard if there was an emergency
I found that using the school was popular in the evenings, and with being such a big yard there wasn't any restrictions on times to go there so I'd ride about 9pm when the school was quiet. You could private hire the school though for £5 an hr which was useful if having lessons.
I would ask if you can have any RI to teach you there. And any farrier/vet, as you may want to keep using your current ones not ones they use. (The big yard I was on allowed anyone you wanted).
Also it was good being so big - there was a huge range Of people and their horsey interests - so if for example you wanted to do A particular NH method then there was always another few people who did it so you were never the 'odd one out' and people didnt judge. Whereas for example I've been on really small yards where everyone was traditional and my NH interest was frowned upon.
Also if 24/7 really was 365 days a year irrelevant of weather etc although perhaps you may choose to stable in bad weather anyway whereas we didnt, but that big yard still allowed 24/7/365 irrelevant if weather. The main issue was more about restricted grazing through the summer, they only had limited sicky paddocks kept for the more 'ill' horses so my Cobbies had to be turned out in a huge field and got fat (even with muzzle use).
Yeh ask about if dogs allowed and if they have to remain on leads everywhere (that's if you have a dog!) it is much better at our current yard where there's no 'leads' rule as I can exercise the dogs there whilst sorting the horses, it was a pain at other yards when they had to stay on the lead