Michael and Jana Novak have an interesting essay on the Founders and their religious faith over at National Review Online.
It's an informative read, that unfortunately leaves you wanting more. I found the following tidbit rather amusing:
As the greatest of all American historians, Gordon Wood, has been pointing out very forcefully in recent months, he has not found a single atheist during the Founding period (not even Tom Paine), and certainly not among the Founders. Second, he finds even the least religious of the Founders considerably more religious than the average professor at American universities today.
Using university professors as the standard isn't a very high bar.