You betcha!!! It's a great goal. Take lots of pictures and movies of their everyday life, especially when things are the usual hectic stuff. Years later you will look back on those moments and have the best time remembering. Another great goal for a stay at home mom is to make EACH child their own photo albums that will be theirs someday. Of course make a bunch of photo albums for you and your husband, but make copies at the same time to make for them. They will LOVE it.
If you do it, do it because you enjoy child-care, not for the children to be grateful or such when grown. It's unpredictable what will be when they are adults, just luck if they are exactly as you wish.
Being at home is a perfectly fine goal to have. My mother stayed home, and I have so much love, respect, admiration, and appreciation for her! Did I feel that when I was a kid? Absolutely! I loved having her there for me, and I was thankful.
As for me, I work from home every day, so I feel like I have the best of both worlds. I can easily get to my child's school for class parties or other events. I can take her to dance class and cheer practice. I just manage my calendar around these things so that I don't miss anything.
If you decide to work, find an employer that allows telecommuting. It's so much easier to have work-life balance.
There's been a change of perception over the past fifty years and lots of people look down on stay-at-home mothers, but it's still a noble task and one that your kids will appreciate.
When Nikita Khrushchev was the Russian premier, back in the early 1960s, we used to hear horror stories about conditions being so bad that, as soon as babies were old enough to leave in a creche, or childcare, their mothers had to go back to work to help make ends meet.
In the West we're now doing the same thing, and willingly, because for many women there's much more fulfillment in a career (or even a job as a checkout chick) than in housework and child-raising.
It's up to you how you prefer to spend your life. Just don't fall into the trap of thinking that the world begins and ends in your home and with your children. Allow yourself to grow, to have interests outside the house. to blossom as a woman. And try to keep your work skills up-to-date so that you can find work, if you want to, when the kids are older.