A renowned sculptor has said he is "thrilled" to have been chosen to create a statue of Queen Elizabeth II for a new national memorial, saying he would like it to be an "object of delight for people".