Congrats Roberto on moving out of debt! A day to celebrate.
Vis a vis water - I'd question how much Aloe will remove moisture from the air. My guess is that the net water movement will be out of the leaves and into the air if anything. The smooth waxy leaves are designed to minimise water loss rather than facilitate water uptake. Certainly the shape of the Aloe plant is probably designed to trap mist or fog from the air and channel it to the roots of the plant - but indoors I'm not sure you'll have that degree of moisture. I'm not an expert on Aloe, but that's my guess on it.
Instead, could you install a bypass line so that in summer, you can simply stop splashing the water down onto the indoor wetland area for some or all of the wetter season? Otherwise there may be a risk of excessively high moisture content and consequent damage to the structural integrity of your timberwork. Again, just a guess on my part.
Oh, you may want to have a look at John Todd's Eco Machines: https://www.oceanarksint.org/portfolio/eco-machines/
and Tom Worrell's Living Machines: http://livingmachines.com/Home.aspx
I look forward to the photos.