Will a person get rewards for donating to a borehole project (with the intention of doing it for Sadaqatu Jariyah) which turns out that the borehole has no water in it after construction?

Shaykh Muhammad Sheeth AbdulQadir