Pierre Trudeau was a practicing Catholic. Tommy Douglas was an ordained minister. Mulroney, Chretien, Martin were all raised Catholic. I don't know if they still went to church. 

Separation of church and state doesn't mean that all leaders have to be atheist.