We have both. If I had to choose, borehole wins hands down.
Problems with rainwater harvesting:
1. Bird poo / dust / whatever is on roof. You can install a filter, but the water still tends to develop an odour after a while in the tank.
2. Even if you install a 10kl tank, it does not last very...