The scheme in Aberaeron is 'days away from completion' but the local council is facing up to a significant overspend