Millions of UK grandparents are avoiding booking holidays so they can save money to give to their grandchildren, a new survey suggests.