A long-awaited new car park in a busy Lake District village will open for the first time at the end of this week.