A teenage boy is missing from waters near Sydney's northern beaches after a boat capsize left one man dead and another injured.