Is vannak really necessary?
Yes. At least it is in the plural.
In the singular, you can say "Hol van a piac?" or "Hol a piac?".
why not piacokat?
Because the markets is the subject - they are the things that "are" somewhere.
Would 'Hol a piacok vannak?' work also?