There's no such thing as an Apple TV (unless you convert a Mac to be a TV monitor I suppose). There's a box which enables your smart TV to get Apple content.
Android tv is just sort of smart tv.
You don’t need a smart tv with a Sky Q box.
However it would seem a good idea to get one if you’re getting a new tv. Pretty soon there won’t be any other sort