There are government buses that ply within the city limits. But they are quite crowded. For some areas there are less bus frequencies.
Private cars are available at the main bus station. If you want travel comfortably within Thiruvarur better opt for rental cabs.
Share autos and metre autos are also available at Thiruvarur.