OMG, that pic of big soldier hubby and little teeny kitten is just precious!
First, and I know folks with more experience raising newborns will say the same thing, it was absolutely not your fault that Marie couldn’t make it. The survival rate, all to sadly, is not as high as we would wish for these little ones. Take comfort in the fact that she had a loving, warm and sheltering home, even if it was only for a short while. Raise and love little Riley and she will give you all the love back two-fold: once for herself and once for her sister-now-in-the-Meadow Marie.
As far as the water goes, again, others please chime in, but I would tend to think as long as you are adding water to her wet food and she is peeing normally, you should be fine. My own semi-feral Jes (rescued from the forest preserve at maybe 6 months old, and still spooky even full-grown) took awhile to get used to a water bowl; he would either lap his tongue in the air above the water, or dip his face too far in and sneeze when it went up his nose. He got the hang of it eventually.
And welcome to TDK! Look forward to more posts (and pics!) of Riley as she grows.