3D coat is very popular for handpainted texturing. You could also use Krita or Photoshop, for most environment can paint a lot of your maps in 2D. Just a note though, it's best to use tiling textures for an object like this rather than unwrapping it to a single map.