"It has this air of luxury, but it's not too pretentious," designer Tiffany Brooks says of the home's beachy location