A cake made with water will definitely have a lighter, more airy texture. If you replace the water with milk, the recipe will instantly become more decadent, softer, and tender. Also, if you add buttermilk, the texture will become creamier and richer.