More than three quarters of UK households would support renewable energy projects such as wind turbines and solar farms if the profits generated benefitted the local community, a poll has found.