A nine-year-old boy has been found dead after drowning in a drainpipe in the Northern Territory on Tuesday.