
To be perfectly honest, there are two ways of doing this. One way is getting a separate Sky and Freeview box in each room. This will probably mean several satellite dishes (it gets hard to put more than two LNB's per dish, and you need one LNB per satellite tuner - two for a Sky+/Sky HD box). You may be more lucky with a Freeview aerial, but even here you may need more than one twig on the roof (this is a common problem in blocks of flats).
A better plan might be to get a CEDIA installer (or similar) to do the job for you. The dealer may well suggest exactly the schema I've mentioned above, or come up with a more equitable system (remember, you will have to pay up multiple Sky subscriptions - it may be possible to find a solution that uses less boxes with local control.
A lot of the best connectivity here is necessarily complex and outside the perview of DIY installation.