Gamebanana is often where people get most of their custom textures. You can also make custom textures, but it's quite tedious. However, making your own textures will really help your map make an impression as long as the textures are done well and the map looks good.