The hole would be in the bottom of the tank.... you could build a standpipe yourself (that is a very good first project when learning plumbing).

But there's lots of different way to do it... this just happens to be the way I like to do it.