Will burrowed zerg units still activate the Xel'Naga Watchtowers?

No, at the moment burrowed units do not activate Watch Towers. Neither do flying units but invisible units like the Dark Templar or a cloaked Ghost will activate them.