We live in this area, and have four dc at secondary or post-secondary age, so I know a bit about it... 
I would say that of the primaries you mention, Yerbury is the most likely to have kids going to private or state selective schools. But Y has a micro-catchment these days, so if you live in the catchment for Torriano, you almost certainly won't be in the Yerbury catchment. Ditto Eleanor Palmer, which is the other local primary that people go nuts about. Don't get caught up in the hysteria, the other local primaries are just as good without the fuss.
For people who don't want private or selective secondary, currently popular local schools are Parliament Hill for girls and William Ellis for boys. Acland Burghley has had a difficult few years, but there's every reason to believe they can pull through that - it's historically been a popular school, although like other local schools they are very definitely comprehensives with a mixed intake, and proud of that. All the people I know with dc currently at those three schools are generally pretty happy. Acland Burghley hasn't had a distance cut-off for the past few years because of the uncertainty over change of head, but I presume that will change at some point as the new regime beds in and prospective parents get more confident. AB is mixed, but very boy-heavy because of the number of girls' schools in the area.
The other local school is Holloway, which historically doesn't attract any interest from m/c families, but that doesn't mean it's a bad school, just a bit of an unknown quantity.
People whose dses go to Central Foundation seem to be very happy with it, but I don't know if the intake extends as far as North Islington - Islington council has intake area maps on the website for the past 5 years or so, so you can easily check.
Of the Catholic schools, St Aloysius is not hugely oversubscribed with Catholic applicants, so there may be places for non-Catholics, but you'd need to check that and obviously it might change over time. It does have a very strongly Catholic culture, so might be a slightly odd experience for a child not from that background. They are big on sports and have access to their own playing field, which is a bonus.
The new City Academy is an unknown quantity, but presumably will take the girls from the current Mt Carmel (though I think parents are being offered Bishop Douglass in Finchley if they want to stay in the Catholic system). Historically Mt Carmel hasn't been a particularly sought-after school, and tbh the City Academies formed from other Islington secondaries like Islington Green have in many ways kept some of the characteristics of their predecessor schools in terms of intake and outcomes - I don't think any of them have become hugely sought-after, so I wouldn't be holding my breath for that one. But if you have a very young ds, there's time to see what happens there. In any case, the ethos of the Academy schools is very different to the liberal ethos of the main Tufnell Park schools like Burghley, Ellis and Parli, so which you prefer will depend on whether you like the whole strict uniform/zero tolerance thing or prefer things more relaxed.
But tbh it is very early days to start fretting about secondary schools, just keep a vague eye on what's happening. For example, Camden have only recently started cracking down on address fraud for applications, which has hugely increased the catchment area of ridiculously popular schools like Camden Girls, which will presumably have a knock-on effect on applications and intake areas for other local schools. But local schools are definitely not a disaster area - people who are the most critical are generally the ones looking to justify their decisions to move/go private/tutor for selective, so you need to develop a bit of a bullshit filter for much of what you hear.