The economy of a Cork harbour town is to get a boost of up to €600,000 thanks to a major regatta.