Sir Rod Stewart will welcome his fifth grandchild soon