Can I purchase a Sky dish and just take my cable box from home when I go on holiday?

No. You need a proper Sky or freesat receiver.