Caerphilly residents have been warned of "difficult times" as the borough council looks to manage a £47 million gap in its budget.