A Pink Floyd star will open the gardens of his Wiltshire home to the public with thousands of people expected to attend.