I too have often contemplated a fountain, but as already mentioned, it can significantly impact humidity levels. Bearded Dragons needs relatively low humidity, so care must be taken to avoid this.
That said, chronic dehydration is perhaps a more serious concern, especially for those animals...