Multi-million euro plans have been unveiled to upgrade a historic castle and enhance recreational amenities in a North Cork town.