This picturesque Cornish riverside village boasts stunning scenery, subtropical gardens, and celebrity residents