Modified gravity a la Galileon: Late time cosmic acceleration and observational constraints