For a more organic, less repetitive look, designers often use high-resolution photos of real canvas. However, a photo of canvas is a rectangle with edges; it must be made seamless manually.
Creating the texture is only half the battle; applying it correctly is crucial. Simply placing the texture layer over your artwork will obscure your work. The solution lies in found in the Layers panel.